Skip Headers

Oracle® Database Data Warehousing Guide 10g Release 2 (10.2) Part Number B14223-02 |
Home | Book List | Contents | Master Index | Feedback

Previous
| View PDF

# Index

A B C D E F G H I J K L M N O P Q R S T U V W X

## A

  adaptive multiuser
    algorithm for, 25.4.7.1
    definition, 25.4.7
  affinity
    parallel DML, 25.7.2
    partitions, 25.7
  aggregates, 8.2.1, 18.6.5
    computability check, 18.1.3.4
  ALL_PUBLISHED_COLUMNS view, 16.9.5
  ALTER INDEX statement
    partition attributes, 5.6.7
  ALTER MATERIALIZED VIEW statement, 8.3
  ALTER SESSION statement
    ENABLE PARALLEL DML clause, 25.3.3.3
    FORCE PARALLEL DDL clause, 25.4.5.4.1, 25.4.5.7
      create or rebuild index, 25.4.5.5.1, 25.4.5.7
      create table as select, 25.4.5.6.3, 25.4.5.7
      move or split partition, 25.4.5.5.2, 25.4.5.7
    FORCE PARALLEL DML clause
      insert, 25.4.5.3, 25.4.5.3.1, 25.4.5.7
      update and delete, 25.4.5.2, 25.4.5.2.1, 25.4.5.7
  ALTER TABLE statement
    NOLOGGING clause, 25.8.10.2
  altering dimensions, 10.6
  amortization
    calculating, 22.5
  analysis tools
    described, 23.2.3
  analytic functions, 22.3.5
    concepts, 21.1
  analyzing data
    for parallel processing, 25.6.7
  APPEND hint, 25.8.10.2
  applications
    data warehouses
      star queries, 19.3
    decision support, 25.1
    decision support systems (DSS), 6.1.1
      parallel SQL, 25.3.2.2
    direct-path INSERT, 25.3.3.2.4
    parallel DML, 25.3.3.2
  ARCH processes
    multiple, 25.8.8.6
  architecture
    data warehouse, 1.2
    MPP, 25.7.2
    SMP, 25.7.2
  asynchronous AutoLog publishing
    latency for, 16.6.2, 16.6.2
    location of staging database, 16.6.2, 16.6.2
    requirements for, 16.6.1.1, 16.6.1.3
    setting database initialization parameters for, 16.6.3.4
  asynchronous Autolog publishing
    source database performance impact, 16.6.2, 16.6.2, 16.6.2
  Asynchronous Change Data Capture
    columns of built-in Oracle datatypes supported by, 16.11.4
  asynchronous Change Data Capture
    archived redo log files and, 16.11.1
    ARCHIVELOGMODE and, 16.11.1
    supplemental logging, 16.11.2
    supplemental logging and, 16.2.2
  asynchronous change sets
    disabling, 16.9.2.2
    enabling, 16.9.2.2
    exporting, 16.9.4.1
    importing, 16.9.4.1
    managing, 16.9.2
    recovering from capture errors, 16.9.2.4
      example of, 16.9.2.4.1, 16.9.2.4.2
    removing DDL, 16.9.2.4.2
    specifying ending values for, 16.9.2.1
    specifying starting values for, 16.9.2.1
    stopping capture on DDL, 16.9.2.3
      excluded statements, 16.9.2.3
  asynchronous change tables
    exporting, 16.9.4.1
    importing, 16.9.4.1
  asynchronous HotLog publishing
    latency for, 16.6.2
    location of staging database, 16.6.2
    requirements for, 16.6.1.1
    setting database initialization parameters for, 16.6.3.2, 16.6.3.3, 16.6.3.4, 16.6.3.4
  asynchronous Hotlog publishing
    source database performance impact, 16.6.2
  asynchronous I/O, 25.5.3.4
  attributes, 2.2, 10.2
  Automatic Storage Management, 4.2

## B

  bandwidth, 25.1
  bind variables
    with query rewrite, 18.3.10
  bitmap indexes, 6.1
    nulls and, 6.1.3
    on partitioned tables, 6.1.4
    parallel query and DML, 6.1.1, 6.1.1
  bitmap join indexes, 6.1.5
  B-tree indexes, 6.2
    bitmap indexes versus, 6.1.2
  build methods, 8.3.4
  business intelligence
    queries, 24
  business rules
    violation of, 14.4.1

## C

  capture errors
    recovering from, 16.9.2.4
  cardinality
    degree of, 6.1.2
  CASE expressions, 21.15
  cell referencing, 22.2.4
  Change Data Capture, 12.2.3
    asynchronous
      Streams apply process and, 16.6.4
      Streams capture process and, 16.6.4
    benefits for subscribers, 16.1.3.2
    choosing a mode, 16.6.2
    effects of stopping on DDL, 16.9.2.3
    latency, 16.6.2
    location of staging database, 16.6.2
    modes of data capture
      asynchronous AutoLog, 16.2.2.3
      asynchronous Distributed HotLog, 16.2.2.2
      asynchronous HotLog, 16.2.2.1
      synchronous, 16.2.1
    Oracle Data Pump and, 16.9.4
    removing from database, 16.12
    restriction on direct-path INSERT statement, 16.10.1
    setting up, 16.6
    source database performance impact, 16.6.2
    static data dictionary views, 16.5
    supported export utility, 16.9.4
    supported import utility, 16.9.4
    synchronous, 12.2.3.3
    systemwide triggers installed by, 16.12
  Change Data Capture publisher
    default tablespace for, 16.6.1.2
  change sets
    defined, 16.3
    effects of disabling, 16.9.2.2
    managing asynchronous, 16.9.2
    synchronous Change Data Capture and, 16.3
    valid combinations with change sources, 16.3.1
  change sources
    asynchronous AutoLog Change Data Capture and, 16.2.2.3
    asynchronous Distributed HotLog Change Data Capture and, 16.2.2.2
    database instance represented, 16.3.1
    defined, 16.1.3.1, 16.1.3.1
    HOTLOG_SOURCE, 16.2.2.1
    SYNC_SOURCE, 16.2.1
    valid combinations with change sets, 16.3.1
  change tables
    adding a column to, 16.9.5
    control columns, 16.9.3.2
    defined, 16.1.3.1
    dropping, 16.9.3.6
    dropping with active subscribers, 16.9.3.6
    effect of SQL DROP USER CASCADE statement on, 16.9.3.6
    exporting, 16.9.4
    granting subscribers access to, 16.9.3.4
    importing, 16.9.4
    importing for Change Data Capture, 16.9.4.3
    managing, 16.9.3
    purging all in a named change set, 16.9.3.5
    purging all on staging database, 16.9.3.5
    purging by name, 16.9.3.5
    purging of unneeded data, 16.9.3.5
    source tables referenced by, 16.9.3.1
    tablespaces created in, 16.9.3.1
  change-value selection, 16.1.1
  columns
    cardinality, 6.1.2
  COMMIT_TIMESTAMP$
    control column, 16.9.3.2
  common joins, 18.1.3.1.1
  COMPLETE clause, 8.3.7
  complete refresh, 15.3.1
  complex queries
    snowflake schemas, 19.3.1
  composite
    columns, 20.6
    partitioning, 5.1.1.4
    partitioning methods, 5.1.1.4
      performance considerations, 5.1.3.4, 5.1.3.6
  compression
    See data segment compression, 8.3.3
  concatenated groupings, 20.7
  concatenated ROLLUP, 20.10.1
  concurrent users
    increasing the number of, 25.5.1.2
  configuration
    bandwidth, 4.1.1
  constraints, 7.1, 10.4
    foreign key, 7.3.2
    parallel create table, 25.4.5.6
    RELY, 7.3.3
    states, 7.2
    unique, 7.3.1
    view, 7.3.7, 18.3.5
    with partitioning, 7.3.6
    with query rewrite, 18.6.1
  control columns
    used to indicate changed columns in a row, 16.9.3.3
  controls columns
    COMMIT_TIMESTAMP$, 16.9.3.2
    CSCN$, 16.9.3.2
    OPERATION$, 16.9.3.2
    ROW_ID$, 16.9.3.2
    RSID$, 16.9.3.2
    SOURCE_COLMAP$, 16.9.3.2
      interpreting, 16.9.3.3
    SYS_NC_OID$, 16.9.3.2
    TARGET_COLMAP$, 16.9.3.2
      interpreting, 16.9.3.3
    TIMESTAMP$, 16.9.3.2
    USERNAME$, 16.9.3.2
    XIDSEQ$, 16.9.3.2
    XIDSLT$, 16.9.3.2
    XIDUSN$, 16.9.3.2
  cost-based rewrite, 18.1.1
  CPU
    utilization, 25.1
  CREATE DIMENSION statement, 10.2
  CREATE INDEX statement, 25.8.9
    partition attributes, 5.6.7
    rules of parallelism, 25.4.5.5.1
  CREATE MATERIALIZED VIEW statement, 8.3
    enabling query rewrite, 17.2
  CREATE SESSION privilege, 16.6.1.1
  CREATE TABLE AS SELECT
    rules of parallelism
      index-organized tables, 25.1.3
  CREATE TABLE AS SELECT statement, 25.6.4, 25.8.4
    rules of parallelism
      index-organized tables, 25.3.2.1
  CREATE TABLE privilege, 16.6.1.1
  CREATE TABLE statement
    AS SELECT
      decision support systems, 25.3.2.2
      rules of parallelism, 25.4.5.6
      space fragmentation, 25.3.2.6
      temporary storage space, 25.3.2.5
    parallelism, 25.3.2.2
      index-organized tables, 25.1.3, 25.3.2.1
  CSCN$
    control column, 16.9.3.2
  CUBE clause, 20.3
    partial, 20.3.3
    when to use, 20.3.1
  cubes
    hierarchical, 9.2.1
  CUME_DIST function, 21.2.3

## D

  data
    integrity of
      parallel DML restrictions, 25.3.3.10
    partitioning, 5.1
    purging, 15.2.3, 15.2.3
    sufficiency check, 18.1.3.2
    transformation, 14.3
    transportation, 13.2.1
  data compression
    See data segment compression, 8.3.3
  data cubes
    hierarchical, 20.7.1
  data densification, 21.16
    time series calculation, 21.17
    with sparse data, 21.16.2
  data dictionary
    asynchronous change data capture and, 16.7.4
  data extraction
    with and without Change Data Capture, 16.1.2
  data manipulation language
    parallel DML, 25.3.3
    transaction model for parallel DML, 25.3.3.4
  data marts, 1.2.3
  data mining, 23.1
  data rules
    violation of, 14.4.2
  data segment compression, 3.2.3.1
    bitmap indexes, 5.1.4.1
    materialized views, 8.3.3
    partitioning, 3.2.3.1, 5.1.4
  data transformation
    multistage, 14.1.1.1
    pipelined, 14.1.1.2
  data warehouse, 8.1
    architectures, 1.2
    dimension tables, 8.1.6
    dimensions, 19.3
    fact tables, 8.1.6
    logical design, 2.2
    partitioned tables, 5.1.3.1
    physical design, 3.1
    refresh tips, 15.3.9
    refreshing table data, 25.3.3.2.1, 25.3.3.2.1
    star queries, 19.3
  database
    scalability, 25.3.3.2
    staging, 8.1
  database initialization parameters
    adjusting when Streams values change, 16.6.4
  database writer process (DBWn)
    tuning, 25.8.8.7
  DATE datatype
    partition pruning, 5.5.1.3
    partitioning, 5.5.1.3
  date folding
    with query rewrite, 18.3.4
  DB_BLOCK_SIZE initialization parameter, 25.5.3.2
    and parallel query, 25.5.3.2
  DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter, 25.5.3.3
  DBA role, 16.6.1.1
  DBA_DATA_FILES view, 25.6.7.7
  DBA_EXTENTS view, 25.6.7.7
  DBMS_ADVISOR.TUNE_MVIEW package, 8.3.5
  DBMS_CDC_PUBLISH package, 16.1.3.1
    privileges required to use, 16.6.1.1
  DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE PL/SQL procedure, 16.9.3.6
  DBMS_CDC_PUBLISH.PURGE PL/SQL procedure, 16.9.3.5, 16.9.3.5
  DBMS_CDC_PUBLISH.PURGE_CHANG_SET PL/SQL procedure, 16.9.3.5
  DBMS_CDC_PUBLISH.PURGE_CHANGE_TABLE PL/SQL procedure, 16.9.3.5
  DBMS_CDC_SUBSCRIBE package, 16.1.3.2
  DBMS_CDC_SUBSCRIBE.PURGE_WINDOW PL/SQL procedure, 16.9.3.5
  DBMS_ERROR package, 14.4.2.2
  DBMS_JOB PL/SQL package, 16.9.3.5
  DBMS_MVIEW package, 15.3.5, 15.3.5
    EXPLAIN_MVIEW procedure, 8.7.1
    EXPLAIN_REWRITE procedure, 18.5.2
    REFRESH procedure, 15.3, 15.3.6
    REFRESH_ALL_MVIEWS procedure, 15.3
    REFRESH_DEPENDENT procedure, 15.3
  DBMS_STATS package, 18.1.1
  decision support systems (DSS)
    bitmap indexes, 6.1.1
    disk striping, 25.7.1
    parallel DML, 25.3.3.2
    parallel SQL, 25.3.2.2, 25.3.3.2
    performance, 25.3.3.2
    scoring tables, 25.3.3.2.3
  default partition, 5.1.1.3
  degree of cardinality, 6.1.2
  degree of parallelism, 25.2.1, 25.4.2, 25.4.5, 25.4.5.2.2
    and adaptive multiuser, 25.4.7
    between query operations, 25.2.4.3
    parallel SQL, 25.4.3
  DELETE statement
    parallel DELETE statement, 25.4.5.2
  DENSE_RANK function, 21.2.1
  densification
    data, 21.16
  design
    logical, 3.1
    physical, 3.1
  dimension levels
    skipping, 10.2
  dimension tables, 2.4, 8.1.6
    normalized, 10.2.3
  dimensional modeling, 2.2
  dimensions, 2.4.2, 10.1, 10.4
    altering, 10.6
    analyzing, 20.1.1
    creating, 10.2
    definition, 10.1
    dimension tables, 8.1.6
    dropping, 10.7
    hierarchies, 2.4.2.1
    hierarchies overview, 2.4.2.1
    multiple, 20.1.1
    skipping levels, 10.2
    star joins, 19.3
    star queries, 19.3
    validating, 10.5
    with query rewrite, 18.6.2
  direct-path INSERT
    restrictions, 25.3.3.9
  direct-path INSERT statement
    Change Data Capture restriction, 16.10.1
  Discoverer, 8.3.1
  disk affinity
    parallel DML, 25.7.2
    partitions, 25.7
  disk redundancy, 4.1.3
  disk striping
    affinity, 25.7
  DISK_ASYNCH_IO initialization parameter, 25.5.3.4, 25.5.3.4
  distributed transactions
    parallel DDL restrictions, 25.1.3
    parallel DML restrictions, 25.1.3, 25.3.3.12
  DML access
    subscribers, 16.9.3.4
  DML_LOCKS initialization parameter, 25.5.2.3.4
  downstream capture, 16.7.4
  drilling down, 10.1
    hierarchies, 10.1
  DROP MATERIALIZED VIEW statement, 8.3
    prebuilt tables, 8.4
  dropping
    dimensions, 10.7
    materialized views, 8.6
  dropping change tables, 16.9.3.6
  DSS database
    partitioning indexes, 5.6.6

## E

  ENFORCED mode, 17.2.3
  ENQUEUE_RESOURCES initialization parameter, 25.5.2.3.4
  entity, 2.2
  equipartitioning
    examples, 5.6.1.1
    local indexes, 5.6.1
  error logging, 14.4
    table, 14.4.2.2
  errors
    handling, 14.4
      scenarios, 14.5.3
    ORA-31424, 16.9.3.6
    ORA-31496, 16.9.3.6
  ETL. See extraction, transformation, and loading (ETL), 11.1
  EXCHANGE PARTITION statement, 7.3.6
  EXECUTE privilege, 16.6.1.1
  EXECUTE_CATALOG_ROLE privilege, 16.6.1.1
  execution plans
    parallel operations, 25.6.4
    star transformations, 19.4.2.2
  EXPAND_GSET_TO_UNION hint, 18.3.7.2, 18.6.10.4
  EXPLAIN PLAN statement, 18.5.1, 25.6.3
    partition pruning, 5.5.1.3
    query parallelization, 25.8.7
    star transformations, 19.4.2.2
  exporting
    a change table, 16.9.4
    asynchronous change sets, 16.9.4.1
    asynchronous change tables, 16.9.4.1
    EXP utility, 12.3.1.3
  expression matching
    with query rewrite, 18.3.9
  extents
    parallel DDL, 25.3.2.6
  external tables, 14.2.2
  extraction, transformation, and loading (ETL), 11.1
    overview, 11.1
    process, 7.1
  extractions
    data files, 12.3.1
    distributed operations, 12.3.2
    full, 12.2.1
    incremental, 12.2.1.2
    OCI, 12.3.1.2
    online, 12.2.2.1
    overview, 12.1
    physical, 12.2.2
    Pro*C, 12.3.1.2
    SQL*Plus, 12.3.1.1

## F

  fact tables, 2.4, 2.4.1
    star joins, 19.3
    star queries, 19.3
  facts, 10.1
  FAST clause, 8.3.7
  fast refresh, 15.3.2
    restrictions, 8.3.7.1
    with UNION ALL, 15.3.18
  FAST_START_PARALLEL_ROLLBACK initialization parameter, 25.5.2.3.2
  features, new, Preface
  files
    ultralarge, 3.2.2
  filling gaps
    with data, 21.16.6
  FIRST_ROWS(n) hint, 25.8.13
  FIRST_VALUE function, 21.3.7
  FIRST/LAST functions, 21.6
  FOR loops, 22.3.1
  FORCE clause, 8.3.7
  foreign key
    constraints, 7.3.2
    joins
      snowflake schemas, 19.3.1
  fragmentation
    parallel DDL, 25.3.2.6
  FREELISTS parameter, 25.8.8.5
  frequent itemsets, 21.11
  full partition-wise joins, 5.2.1
  full table scans
    parallel execution, 25.1.2
  functions
    analytic, 22.3.5
    COUNT, 6.1.3
    CUME_DIST, 21.2.3
    DENSE_RANK, 21.2.1
    FIRST_VALUE, 21.3.7
    FIRST/LAST, 21.6
    GROUP_ID, 20.4.4
    GROUPING, 20.4
    GROUPING_ID, 20.4.3
    LAG/LEAD, 21.5
    LAST_VALUE, 21.3.7
    linear regression, 21.9
    NTILE, 21.2.5
    parallel execution, 25.3.4
    PERCENT_RANK, 21.2.4
    RANK, 21.2.1
    ranking, 21.2
    RATIO_TO_REPORT, 21.4.1
    REGR_AVGX, 21.9.2
    REGR_AVGY, 21.9.2
    REGR_COUNT, 21.9.1
    REGR_INTERCEPT, 21.9.3
    REGR_SLOPE, 21.9.3
    REGR_SXX, 21.9.5
    REGR_SXY, 21.9.5
    REGR_SYY, 21.9.5
    reporting, 21.4
    ROW_NUMBER, 21.2.6
    WIDTH_BUCKET, 21.13, 21.13.1
    window, 22.3.5
    windowing, 21.3

## G

  global
    indexes, 25.8.8.3
  global indexes
    partitioning, 5.6.2
      managing partitions, 5.6.2.2
      summary of index types, 5.6.3
  GRANT statement, 16.9.3.4
  granules, 25.2.5
  GROUP_ID function, 20.4.4
  grouping
    compatibility check, 18.1.3.3
    conditions, 18.6.6
  GROUPING function, 20.4
    when to use, 20.4.2
  GROUPING_ID function, 20.4.3
  GROUPING_SETS expression, 20.5
  groups, instance, 25.4.3.6
  GT GlossaryTitle, Glossary
  GV$FILESTAT view, 25.6.7

## H

  hash partitioning, 5.1.1.2
  HASH_AREA_SIZE initialization parameter
    and parallel execution, 25.5.2.1.1
  hierarchical cubes, 9.2.1, 20.10.1
    in SQL, 20.10
  hierarchies, 10.1
    how used, 2.4.2.1
    multiple, 10.2.2
    overview, 2.4.2.1, 2.4.2.1
    rolling up and drilling down, 10.1
  high boundary
    defined, 16.1.3.2
  hints
    APPEND, 25.8.10.2
    EXPAND_GSET_TO_UNION, 18.3.7.2, 18.6.10.4
    FIRST_ROWS(n), 25.8.13
    NOAPPEND, 25.8.10.2
    NOWRITE, 18.6.10.1
    PARALLEL, 25.4.3.1, 25.8.2, 25.8.10.1
    PARALLEL_INDEX, 25.4.3.1
    query rewrite, 17.2, 18.6.10.1
    REWRITE, 18.6.10.1
    REWRITE_OR_ERROR, 18.6.10.2
  histograms
    creating with user-defined buckets, 21.15.1
  HOTLOG_SOURCE change sources, 16.2.2.1
  hypothetical rank, 21.8

## I

  importing
    a change table, 16.9.4, 16.9.4.3
    asynchronous change sets, 16.9.4.1
    asynchronous change tables, 16.9.4.1
    data into a source table, 16.9.4.3
  indexes
    bitmap indexes, 6.1.4
    bitmap join, 6.1.5
    B-tree, 6.2
    cardinality, 6.1.2
    creating in parallel, 25.8.9
    global, 25.8.8.3
    global partitioned indexes, 5.6.2
      managing partitions, 5.6.2.2
    local, 25.8.8.3
    local indexes, 5.6.1
    nulls and, 6.1.3
    parallel creation, 25.8.9, 25.8.9, 25.8.9
    parallel DDL storage, 25.3.2.6
    parallel local, 25.8.9
    partitioned tables, 6.1.4
    partitioning, 5.1.2, 5.6.6
    partitions, 5.6
  index-organized tables
    parallel CREATE, 25.1.3, 25.3.2.1
    parallel queries, 25.3.1.1
  initcdc.sql script, 16.12
  initialization parameters
    DB_BLOCK_SIZE, 25.5.3.2
    DB_FILE_MULTIBLOCK_READ_COUNT, 25.5.3.3
    DISK_ASYNCH_IO, 25.5.3.4
    DML_LOCKS, 25.5.2.3.4
    ENQUEUE_RESOURCES, 25.5.2.3.4
    FAST_START_PARALLEL_ROLLBACK, 25.5.2.3.2
    HASH_AREA_SIZE, 25.5.2.1.1
    JOB_QUEUE_PROCESSES, 15.3.9
    LARGE_POOL_SIZE, 25.5.1.5
    LOG_BUFFER, 25.5.2.3.3
    NLS_LANGUAGE, 5.5.1
    NLS_SORT, 5.5.1
    OPTIMIZER_MODE, 15.3.11, 17.2.1
    PARALLEL_ADAPTIVE_MULTI_USER, 25.4.7
    PARALLEL_EXECUTION_MESSAGE_SIZE, 25.5.2.1, 25.5.2.2
    PARALLEL_MAX_SERVERS, 15.3.11, 25.2.2.1, 25.5.1.1.1
    PARALLEL_MIN_PERCENT, 25.4.3.5, 25.5.1.1, 25.5.1.8
    PARALLEL_MIN_SERVERS, 25.2.2, 25.2.2.1, 25.5.1.4
    PGA_AGGREGATE_TARGET, 15.3.11
    QUERY_REWRITE_ENABLED, 17.2, 17.2.1
    QUERY_REWRITE_INTEGRITY, 17.2.1
    SHARED_POOL_SIZE, 25.5.1.5, 25.5.1.5
    STAR_TRANSFORMATION_ENABLED, 19.4.1
    TAPE_ASYNCH_IO, 25.5.3.4
    TIMED_STATISTICS, 25.6.7.6
    TRANSACTIONS, 25.5.2.3.1
  INSERT statement
    functionality, 25.8.10.1
    parallelizing INSERT ... SELECT, 25.4.5.3
  instance groups for parallel operations, 25.4.3.6
  instances
    instance groups, 25.4.3.6
  integrity constraints, 7.1
  integrity rules
    parallel DML restrictions, 25.3.3.10
  invalidating
    materialized views, 9.4
  I/O
    asynchronous, 25.5.3.4
    parallel execution, 25.1
  itemsets
    frequent, 21.11

## J

  Java
    used by Change Data Capture, 16.12
  JOB_QUEUE_PROCESSES initialization parameter, 15.3.9
  join compatibility, 18.1.3.1
  joins
    full partition-wise, 5.2.1
    partial partition-wise, 5.2.2
    partition-wise, 5.2
    star joins, 19.3
    star queries, 19.3

## K

  key lookups, 14.5.1
  keys, 8.1.6, 19.3

## L

  LAG/LEAD functions, 21.5
  LARGE_POOL_SIZE initialization parameter, 25.5.1.5
  LAST_VALUE function, 21.3.7
  level relationships, 2.4.2.1
    purpose, 2.4.2.1.2
  levels, 2.4.2, 2.4.2.1.1
  levels in a dimension
    skipping, 10.2
  linear regression functions, 21.9
  list partitioning, 5.1.1.3
  LOB datatypes
    restrictions
      parallel DDL, 25.1.3, 25.3.2.1
      parallel DML, 25.3.3.9, 25.3.3.9
  local indexes, 5.6.1, 5.6.3, 6.1.1, 6.1.4, 25.8.8.3
    equipartitioning, 5.6.1
  locks
    parallel DML, 25.3.3.8
  LOG_BUFFER initialization parameter
    and parallel execution, 25.5.2.3.3
  logging
    error, 14.4
  LOGGING clause, 25.8.8.8
  logging mode
    parallel DDL, 25.1.3, 25.3.2.1, 25.3.2.3
  logical design, 3.1
  logs
    materialized views, 8.3.9
  lookup tables
    See dimension tables, 8.1.6, 8.1.6
  low boundary
    defined, 16.1.3.2

## M

  manual
    refresh, 15.3.5
  manual refresh
    with DBMS_MVIEW package, 15.3.5
  massively parallel processing (MPP)
    affinity, 25.7, 25.7.2
  massively parallel systems, 25.1
  materialized view logs, 8.3.9
  materialized views
    aggregates, 8.2.1
    altering, 9.6
    build methods, 8.3.4
    checking status, 15.3.13
    containing only joins, 8.2.2
    creating, 8.3
    data segment compression, 8.3.3
    delta joins, 18.1.3.1.3
    dropping, 8.4, 8.6
    invalidating, 9.4
    logs, 12.2.3.3
    multiple, 18.2.8
    naming, 8.3.2
    nested, 8.2.3
    OLAP, 9.2
    OLAP cubes, 9.2.1
    Partition Change Tracking (PCT), 9.1.1
    partitioned tables, 15.4
    partitioning, 9.1
    prebuilt, 8.3
    query rewrite
      hints, 17.2, 18.6.10.1
      matching join graphs, 8.3.6
      parameters, 17.2.1
      privileges, 17.2.4
    refresh dependent, 15.3.8
    refreshing, 8.3.7, 15.3
    refreshing all, 15.3.7
    registration, 8.4
    restrictions, 8.3.6.1
    rewrites
      enabling, 17.2
    schema design, 8.1.7
    schema design guidelines, 8.1.7
    security, 9.5, 9.5
    set operators, 9.2.4
    storage characteristics, 8.3.3
    types of, 8.2
    uses for, 8.1
    with VPD, 9.5.1
  MAXVALUE keyword
    partitioned tables and indexes, 5.5.1.1
  measures, 8.1.6, 19.3
  memory
    configure at 2 levels, 25.5.2
  MERGE statement, 15.2.1
    Change Data Capture restriction, 16.10.1
  MINIMUM EXTENT parameter, 25.3.2.6
  MODEL clause, 22.1
    cell referencing, 22.2.4
    data flow, 22.1.1
    keywords, 22.2.3
    parallel execution, 22.4.1
    rules, 22.2.5
  monitoring
    parallel processing, 25.6.7
    refresh, 15.3.12
  mortgage calculation, 22.5
  MOVE PARTITION statement
    rules of parallelism, 25.4.5.5.2
  multiple archiver processes, 25.8.8.6, 25.8.8.6
  multiple hierarchies, 10.2.2
  multiple materialized views, 18.2.8
  MV_CAPABILITIES_TABLE table, 8.7.1.2

## N

  National Language Support (NLS)
    DATE datatype and partitions, 5.5.1.3
  nested materialized views, 8.2.3
    refreshing, 15.3.17
    restrictions, 8.2.3.4
  net present value
    calculating, 22.5
  NEVER clause, 8.3.7
  new features, Preface
  NLS_LANG environment variable, 5.5.1
  NLS_LANGUAGE parameter, 5.5.1
  NLS_SORT parameter
    no effect on partitioning keys, 5.5.1
  NOAPPEND hint, 25.8.10.2
  NOARCHIVELOG mode, 25.8.8.8
  nodes
    disk affinity in Real Application Clusters, 25.7
  NOLOGGING clause, 25.8.4, 25.8.8.8, 25.8.9
    with APPEND hint, 25.8.10.2
  NOLOGGING mode
    parallel DDL, 25.1.3, 25.3.2.1, 25.3.2.3
  nonprefixed indexes, 5.6.1.2, 5.6.4
    global partitioned indexes, 5.6.2.1
  nonvolatile data, 1.1.3
  NOPARALLEL attribute, 25.8.2
  NOREWRITE hint, 17.2, 18.6.10.1
  NTILE function, 21.2.5
  nulls
    indexes and, 6.1.3
    partitioned tables and indexes, 5.5.1.2

## O

  object types
    parallel query, 25.3.1.4
      restrictions, 25.3.1.4
    restrictions
      parallel DDL, 25.1.3, 25.3.2.1
      parallel DML, 25.3.3.9, 25.3.3.9
  OLAP, 23.1
    applications, 23.2.4
    functions, 23.2.4
    materialized views, 9.2
  OLAP cubes
    materialized views, 9.2.1
  OLTP database
    batch jobs, 25.3.3.2.5
    parallel DML, 25.3.3.2
    partitioning indexes, 5.6.6
  ON COMMIT clause, 8.3.7
  ON DEMAND clause, 8.3.7
  OPERATION$
    control column, 16.9.3.2
  optimization
    partition pruning
      indexes, 5.6.5
    partitioned indexes, 5.6.5
  optimizations
    parallel SQL, 25.2.4
    query rewrite
      enabling, 17.2
      hints, 17.2, 18.6.10.1
      matching join graphs, 8.3.6
    query rewrites
      privileges, 17.2.4
  optimizer
    with rewrite, 17.1
  OPTIMIZER_MODE initialization parameter, 15.3.11, 17.2.1
  ORA-31424 error, 16.9.3.6
  ORA-31496 error, 16.9.3.6
  Oracle Data Pump
    using with Change Data Capture, 16.9.4
  Oracle Real Application Clusters
    disk affinity, 25.7
    instance groups, 25.4.3.6
  ORDER BY clause, 8.3.8
  outer joins
    with query rewrite, 18.6.3

## P

  packages
    DBMS_ADVISOR, 8.1.4
    DBMS_CDC_PUBLISH, 16.1.2
    DBMS_CDC_SUBSCRIBE, 16.1.2
    DBMS_DIMENSION, 10.3.2
    DBMS_ERROR, 14.4.2.2
    DBMS_ERRORLOG, 14.4.2.2, 14.5.3
    DBMS_MVIEW, 8.7.1.1, 15.3
    DBMS_STATS, 18.1.1
  paragraph tags
    GT GlossaryTitle, Glossary
  PARALLEL clause, 25.8.10.1, 25.8.10.3
    parallelization rules, 25.4.5
  PARALLEL CREATE INDEX statement, 25.5.2.3
  PARALLEL CREATE TABLE AS SELECT statement
    resources required, 25.5.2.3
  parallel DDL, 25.3.2
    extent allocation, 25.3.2.6
    parallelization rules, 25.4.5
    partitioned tables and indexes, 25.3.2.1
    restrictions
      LOBs, 25.1.3, 25.3.2.1
      object types, 25.1.3, 25.3.1.4, 25.3.2.1
  parallel delete, 25.4.5.2
  parallel DELETE statement, 25.4.5.2
  parallel DML, 25.3.3
    applications, 25.3.3.2
    bitmap indexes, 6.1.1
    degree of parallelism, 25.4.5, 25.4.5.2.2
    enabling PARALLEL DML, 25.3.3.3
    lock and enqueue resources, 25.3.3.8
    parallelization rules, 25.4.5
    recovery, 25.3.3.6
    restrictions, 25.3.3.9
      object types, 25.3.1.4, 25.3.3.9, 25.3.3.9, 25.3.3.9, 25.3.3.9
      remote transactions, 25.3.3.12
    transaction model, 25.3.3.4
  parallel execution
    full table scans, 25.1.2
    index creation, 25.8.9
    interoperator parallelism, 25.2.4.3
    intraoperator parallelism, 25.2.4.3
    I/O parameters, 25.5.3
    plans, 25.6.4
    query optimization, 25.8.12
    resource parameters, 25.5.2
    rewriting SQL, 25.8.3
    solving problems, 25.8.2
    tuning, 25.1
  PARALLEL hint, 25.4.3.1, 25.8.2, 25.8.10.1
    parallelization rules, 25.4.5
    UPDATE and DELETE, 25.4.5.2
  parallel partition-wise joins
    performance considerations, 5.2.4
  parallel query, 25.3.1
    bitmap indexes, 6.1.1
    index-organized tables, 25.3.1.1
    object types, 25.3.1.4
      restrictions, 25.3.1.4
    parallelization rules, 25.4.5
  parallel SQL
    allocating rows to parallel execution servers, 25.2.4.1
    degree of parallelism, 25.4.3
    instance groups, 25.4.3.6
    number of parallel execution servers, 25.2.2
    optimizer, 25.2.4
    parallelization rules, 25.4.5
    shared server, 25.2.2
  parallel update, 25.4.5.2
  parallel UPDATE statement, 25.4.5.2
  PARALLEL_ADAPTIVE_MULTI_USER initialization parameter, 25.4.7
  PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter, 25.5.2.1, 25.5.2.2
  PARALLEL_INDEX hint, 25.4.3.1
  PARALLEL_MAX_SERVERS initialization parameter, 15.3.11, 25.2.2.1, 25.5.1.1.1
    and parallel execution, 25.5.1.1
  PARALLEL_MIN_PERCENT initialization parameter, 25.4.3.5, 25.5.1.1, 25.5.1.8
  PARALLEL_MIN_SERVERS initialization parameter, 25.2.2, 25.2.2.1, 25.5.1.4
  PARALLEL_THREADS_PER_CPU initialization parameter, 25.4.9
  parallelism, 25.1
    degree, 25.2.1, 25.4.2
    degree, overriding, 25.8.2
    enabling for tables and queries, 25.4.6
    interoperator, 25.2.4.3
    intraoperator, 25.2.4.3
  parameters
    FREELISTS, 25.8.8.5
  partition
    default, 5.1.1.3
  Partition Change Tracking (PCT), 9.1.1, 15.4.1, 18.2.7
    with Pmarkers, 18.2.7.4
  partition pruning, 5.1.5
    dynamic, 5.1.5.4
    static, 5.1.5.3
    techniques, 5.1.5.5
  partitioned outer join, 21.16
  partitioned tables
    data warehouses, 5.1.3.1
    materialized views, 15.4
  partitioning, 12.2.3.2
    composite, 5.1.1.4, 5.1.1.4
    data, 5.1
    data segment compression, 5.1.4
      bitmap indexes, 5.1.4.1
    hash, 5.1.1.2
    indexes, 5.1.2
    list, 5.1.1.3
    materialized views, 9.1
    prebuilt tables, 9.1.3
    range, 5.1.1.1, 5.1.1.1
    range-list, 5.1.3.6
  partitions
    affinity, 25.7
    bitmap indexes, 6.1.4
    DATE datatype, 5.5.1.3
    equipartitioning
      examples, 5.6.1.1
      local indexes, 5.6.1
    global indexes, 5.6.2
    local indexes, 5.6.1
    multicolumn keys, 5.5.1.4
    nonprefixed indexes, 5.6.1.2, 5.6.4
    parallel DDL, 25.3.2.1
    partition bounds, 5.5
    partition pruning
      DATE datatype, 5.5.1.3
      disk striping and, 25.7.1
      indexes, 5.6.5
    partitioning indexes, 5.6, 5.6.6
    partitioning keys, 5.4, 5.4
    physical attributes, 5.6.7
    prefixed indexes, 5.6.1.1
    pruning, 5.1.5
    range partitioning
      disk striping and, 25.7.1
    restrictions
      datatypes, 5.5.1.3
    rules of parallelism, 25.4.5.5.2
  partition-wise joins, 5.2
    benefits of, 5.2.3
    full, 5.2.1
    partial, 5.2.2
  PERCENT_RANK function, 21.2.4
  performance
    DSS database, 25.3.3.2
    prefixed and nonprefixed indexes, 5.6.5
  PGA_AGGREGATE_TARGET initialization parameter, 15.3.11
  physical design, 3.1
    structures, 3.2.1
  pivoting, 14.5.4, 14.5.4
  plans
    star transformations, 19.4.2.2
  PL/SQL packages
    DBMS_JOB, 16.9.3.5
  PL/SQL procedures
    DBMS_CDC_PUBLISH_DROP_CHANGE_TABLE, 16.9.3.6
    DBMS_CDC_PUBLISH.PURGE, 16.9.3.5, 16.9.3.5
    DBMS_CDC_PUBLISH.PURGE_CHANGE_SET, 16.9.3.5
    DBMS_CDC_PUBLISH.PURGE_CHANGE_TABLE, 16.9.3.5
    DBMS_CDC_SUBSCRIBE.PURGE_WINDOW, 16.9.3.5
  Pmarkers
    with PCT, 18.2.7.4
  prebuilt materialized views, 8.3
  predicates
    partition pruning
      indexes, 5.6.5
  prefixed indexes, 5.6.1.1, 5.6.3
  PRIMARY KEY constraints, 25.8.9
  privileges required
    to publish change data, 16.6.1.1
  process monitor process (PMON)
    parallel DML process recovery, 25.3.3.6.2
  processes
    and memory contention in parallel processing, 25.5.1.1.1
  pruning
    partition, 5.1.5
    partitions, 25.7.1
  pruning partitions
    DATE datatype, 5.5.1.3
    EXPLAIN PLAN, 5.5.1.3
    indexes, 5.6.5
  publication
    defined, 16.1.3.1
  publisher
    definition, 16.1.3.1
  publishers
    components associated with, 16.1.3.1
    defined, 16.1.3
    determining the source tables, 16.1.3.1
    privileges for reading views, 16.5
    purpose, 16.1.3.1
    table partitioning properties and, 16.9.3.1
    tasks, 16.1.3.1
  publishing
    asynchronous AutoLog mode
      step-by-step example, 16.7.4
    asynchronous HotLog mode
      step-by-step example, 16.7.2
    synchronous mode
      step-by-step example, 16.7.1
  publishing change data
    preparations for, 16.6
    privileges required, 16.6.1.1
  purging change tables
    automatically, 16.9.3.5
    by name, 16.9.3.5
    in a named changed set, 16.9.3.5
    on the staging database, 16.9.3.5
    publishers, 16.9.3.5
    subscribers, 16.9.3.5
  purging data, 15.2.3

## Q

  queries
    ad hoc, 25.3.2.2
    enabling parallelism for, 25.4.6
    star queries, 19.3
  query delta joins, 18.1.3.1.2
  query optimization, 25.8.12
    parallel execution, 25.8.12
  query rewrite
    advanced, 18.4
    checks made by, 18.1.3
    controlling, 17.2.2
    correctness, 17.2.3
    date folding, 18.3.4
    enabling, 17.2, 17.2
    hints, 17.2, 18.6.10.1
    matching join graphs, 8.3.6
    methods, 18.1
    parameters, 17.2.1
    privileges, 17.2.4
    restrictions, 8.3.6.2
    using equivalences, 18.4
    using GROUP BY extensions, 18.3.7.1
    using nested materialized views, 18.3.1
    using PCT, 18.2.7
    VPD, 9.5.1.1
    when it occurs, 17.1.1
    with bind variables, 18.3.10
    with DBMS_MVIEW package, 18.5.2
    with expression matching, 18.3.9
    with inline views, 18.3.2
    with partially stale materialized views, 18.3.9.1
    with selfjoins, 18.3.3
    with set operator materialized views, 18.3.6
    with view constraints, 18.3.5
  query tools
    described, 23.2.3
  QUERY_REWRITE_ENABLED initialization parameter, 17.2, 17.2.1
  QUERY_REWRITE_INTEGRITY initialization parameter, 17.2.1

## R

  range partitioning, 5.1.1.1, 5.1.1.1
    key comparison, 5.5.1, 5.5.1.4
    partition bounds, 5.5
    performance considerations, 5.1.3.1
  range-list partitioning, 5.1.3.6
  RANK function, 21.2.1
  ranking functions, 21.2
  RATIO_TO_REPORT function, 21.4.1
  REBUILD INDEX PARTITION statement
    rules of parallelism, 25.4.5.5.1
  REBUILD INDEX statement
    rules of parallelism, 25.4.5.5.1
  recovery
    from asynchronous change set capture errors, 16.9.2.4
    parallel DML, 25.3.3.6
  redo buffer allocation retries, 25.5.2.3.3
  redo log files
    archived
      asynchronous Change Data Capture and, 16.11.1
    determining which are no longer needed by Change Data Capture, 16.11.1
  reference tables
    See dimension tables, 8.1.6
  refresh
    monitoring, 15.3.12
    options, 8.3.7
    scheduling, 15.3.14
    with UNION ALL, 15.3.18
  refreshing
    materialized views, 15.3
    nested materialized views, 15.3.17
    partitioning, 15.1
  REGR_AVGX function, 21.9.2
  REGR_AVGY function, 21.9.2
  REGR_COUNT function, 21.9.1
  REGR_INTERCEPT function, 21.9.3
  REGR_R2 function, 21.9.4
  REGR_SLOPE function, 21.9.3
  REGR_SXX function, 21.9.5
  REGR_SXY function, 21.9.5
  REGR_SYY function, 21.9.5
  regression
    detecting, 25.6.1
  RELY constraints, 7.3.3
  remote transactions
    PDML restrictions, 25.1.3
  removing
    Change Data Capture from source database, 16.12
  replication
    restrictions
      parallel DML, 25.3.3.9
  reporting functions, 21.4
  resources
    consumption, parameters affecting, 25.5.2, 25.5.2.3
    limiting for users, 25.5.1.3
    limits, 25.5.1.1
    parallel query usage, 25.5.2
  restrictions
    direct-path INSERT, 25.3.3.9
    fast refresh, 8.3.7.1
    nested materialized views, 8.2.3.4
    parallel DDL, 25.1.3, 25.3.2.1
    parallel DML, 25.3.3.9
      remote transactions, 25.3.3.12
    partitions
      datatypes, 5.5.1.3
    query rewrite, 8.3.6.2
  result set, 19.4.2
  REVOKE statement, 16.9.3.4
  REWRITE hint, 17.2, 18.6.10.1, 18.6.10.1
  REWRITE_OR_ERROR hint, 18.6.10.2
  rewrites
    hints, 18.6.10.1
    parameters, 17.2.1
    privileges, 17.2.4
    query optimizations
      hints, 17.2, 18.6.10.1
      matching join graphs, 8.3.6
  rmcdc.sql script, 16.12
  rolling up hierarchies, 10.1
  ROLLUP, 20.2
    concatenated, 20.10.1
    partial, 20.2.3
    when to use, 20.2.1
  root level, 2.4.2.1.1
  ROW_ID$
    control column, 16.9.3.2
  ROW_NUMBER function, 21.2.6
  RSID$
    control column, 16.9.3.2
  rules
    in MODEL clause, 22.2.5
    in SQL modeling, 22.2.5
    order of evaluation, 22.2.6

## S

  sar UNIX command, 25.6.10
  scalability
    batch jobs, 25.3.3.2.5
    parallel DML, 25.3.3.2
  scalable operations, 25.8.6
  scans
    full table
      parallel query, 25.1.2
  schema-level export operations, 16.9.4.1
  schema-level import operations, 16.9.4.1
  schemas, 19.1
    design guidelines for materialized views, 8.1.7
    snowflake, 2.3
    star, 2.3
    third normal form, 19.1, 19.2
  scripts
    initcdc.sql for Change Data Capture, 16.12
    rmcdc.sql for Change Data Capture, 16.12
  SELECT_CATALOG_ROLE privilege, 16.5, 16.6.1.1
  sessions
    enabling parallel DML, 25.3.3.3
  set operators
    materialized views, 9.2.4
  shared server
    parallel SQL execution, 25.2.2
  SHARED_POOL_SIZE initialization parameter, 25.5.1.5
  SHARED_POOL_SIZE parameter, 25.5.1.5
  simultaneous equations, 22.5
  skewing parallel DML workload, 25.4.4
  SKIP WHEN NULL clause, 10.2
  skipping levels in a dimension, 10.2
  SMP architecture
    disk affinity, 25.7.2
  snowflake schemas, 19.3.1
    complex queries, 19.3.1
  SORT_AREA_SIZE initialization parameter
    and parallel execution, 25.5.2.1.2
  source database
    defined, 16.1.3.1
  source systems, 12.1
  source tables
    importing for Change Data Capture, 16.9.4.3
    referenced by change tables, 16.9.3.1
  SOURCE_COLMAP$
    control column, 16.9.3.2
      interpreting, 16.9.3.3
  space management
    MINIMUM EXTENT parameter, 25.3.2.6
    parallel DDL, 25.3.2.4
  sparse data
    data densification, 21.16.2
  SPLIT PARTITION clause
    rules of parallelism, 25.4.5.5.2
  SQL modeling, 22.1
    cell referencing, 22.2.4
    keywords, 22.2.3
    order of evaluation, 22.2.6
    performance, 22.4
    rules, 22.2.5
    rules and restrictions, 22.3.7
  SQL statements
    parallelizing, 25.1.3, 25.2.4
  SQL*Loader, 25.1.3
  staging
    areas, 1.2.2
    databases, 8.1
    files, 8.1
  staging database
    defined, 16.1.3.1
  STALE_TOLERATED mode, 17.2.3
  star joins, 19.3
  star queries, 19.3
    star transformation, 19.4.2
  star schemas
    advantages, 2.3.1
    defining fact tables, 2.4.1.1
    dimensional model, 2.3.1, 19.3
  star transformations, 19.4.2
    restrictions, 19.4.2.6
  STAR_TRANSFORMATION_ENABLED initialization parameter, 19.4.1
  statistics, 18.6.9
    estimating, 25.6.4
    operating system, 25.6.10
  storage
    fragmentation in parallel DDL, 25.3.2.6
    index partitions, 5.6.7
  STORAGE clause
    parallel execution, 25.3.2.5
  Streams apply parallelism value
    determining, 16.6.4.1, 16.6.4.2
  Streams apply process
    asynchronous Change Data Capture and, 16.6.4
  Streams capture parallelism value
    determining, 16.6.4.1, 16.6.4.2
  Streams capture process
    asynchronous Change Data Capture and, 16.6.4
  striping, 4.1.2
  subpartition
    mapping, 5.1.3.5
    template, 5.1.3.5
  subpartition template, 5.1.3.7
  subqueries
    in DDL statements, 25.3.2.2
  subscriber view
    defined, 16.1.3.2
    returning DML changes in order, 16.9.3.2, 16.9.3.2
  subscribers
    access to change tables, 16.9.3.4
    ALL_PUBLISHED_COLUMNS view, 16.9.5
    components associated with, 16.1.3.2
    controlling access to tables, 16.9.3.4
    defined, 16.1.3
    DML access, 16.9.3.4
    privileges, 16.1.3.2
    purpose, 16.1.3.2
    retrieve change data from the subscriber views, 16.1.3.2
    tasks, 16.1.3.2
  subscribing
    step-by-step example, 16.8
  subscription windows
    defined, 16.1.3.2
  subscriptions
    changes to change tables and, 16.9.5
    defined, 16.1.3.2
    effect of SQL DROP USER CASCADE statement on, 16.9.3.6
  summary management
    components, 8.1.5
  summary tables, 2.4.1
  supplemental logging
    asynchronous Change Data Capture, 16.11.2
    asynchronous Change Data Capture and, 16.2.2
  symmetric multiprocessors, 25.1
  SYNC_SET predefined change set, 16.3
  SYNC_SOURCE change source, 16.2.1
  synchronous Change Data Capture
    change sets and, 16.3
  synchronous change sets
    disabling, 16.9.2.2
    enabling, 16.9.2.2
  synchronous publishing
    latency for, 16.6.2
    location of staging database, 16.6.2
    requirements for, 16.7.1
    setting database initialization parameters for, 16.6.3.1
    source database performance impact, 16.6.2
  SYS_NC_OID$
    control column, 16.9.3.2
  system monitor process (SMON)
    parallel DML system recovery, 25.3.3.6.3

## T

  table differencing, 16.1.1
  table partitioning
    publisher and, 16.9.3.1
  table queues, 25.6.7.9
  tables
    detail tables, 8.1.6
    dimension tables (lookup tables), 8.1.6
    dimensions
      star queries, 19.3
    enabling parallelism for, 25.4.6
    external, 14.2.2
    fact tables, 8.1.6
      star queries, 19.3
    historical, 25.3.3.2.4
    lookup, 19.3
    parallel creation, 25.3.2.2
    parallel DDL storage, 25.3.2.6
    refreshing in data warehouse, 25.3.3.2.1
    STORAGE clause with parallel execution, 25.3.2.5
    summary, 25.3.2.2
  tablespace
    specifying default for Change Data Capture publisher, 16.6.1.2
  tablespaces
    change tables and, 16.9.3.1
    transportable, 12.2.2.2, 13.2.3, 13.2.3.2
  TAPE_ASYNCH_IO initialization parameter, 25.5.3.4, 25.5.3.4
  TARGET_COLMAP$
    control column, 16.9.3.2
      interpreting, 16.9.3.3
  temporary segments
    parallel DDL, 25.3.2.6
  text match, 18.2.1
    with query rewrite, 18.6.4
  third normal form
    queries, 19.2.1
    schemas, 19.2
  time series calculations, 21.17
  TIMED_STATISTICS initialization parameter, 25.6.7.6
  TIMESTAMP$
    control column, 16.9.3.2
  timestamps, 12.2.3.1
  TO_DATE function
    partitions, 5.5.1.3
  transactions
    distributed
      parallel DDL restrictions, 25.1.3
      parallel DML restrictions, 25.1.3, 25.3.3.12
  TRANSACTIONS initialization parameter, 25.5.2.3.1
  transformations, 14.1
    scenarios, 14.5
    SQL and PL/SQL, 14.3.1
    SQL*Loader, 14.2.1
  transportable tablespaces, 12.2.2.2, 13.2.3, 13.2.3.2
  transportation
    definition, 13.1
    distributed operations, 13.2.2
    flat files, 13.2.1
  triggers, 12.2.3.3
    installed by Change Data Capture, 16.12
    restrictions, 25.3.3.11
      parallel DML, 25.3.3.9
  TRUSTED mode, 17.2.3
  two-phase commit, 25.5.2.3.1

## U

  ultralarge files, 3.2.2
  unique
    constraints, 7.3.1, 25.8.9
    identifier, 2.2, 3.2
  update frequencies, 8.1.9
  UPDATE statement, 22.2.8
    parallel UPDATE statement, 25.4.5.2
  update windows, 8.1.9
  UPSERT ALL statement, 22.2.8
  UPSERT statement, 22.2.8
  user resources
    limiting, 25.5.1.3
  USERNAME$
    control column, 16.9.3.2

## V

  V$FILESTAT view
    and parallel query, 25.6.7.7
  V$PARAMETER view, 25.6.7.8
  V$PQ_SESSTAT view, 25.6.5, 25.6.7.6
  V$PQ_SYSSTAT view, 25.6.5
  V$PQ_TQSTAT view, 25.6.6, 25.6.7.9
  V$PX_PROCESS view, 25.6.7.4, 25.6.7.5
  V$PX_SESSION view, 25.6.7.2
  V$PX_SESSTAT view, 25.6.7.3
  V$SESSTAT view, 25.6.7.10, 25.6.10
  V$SYSSTAT view, 25.5.2.3.3, 25.6.7.10, 25.8.8.7
  validating dimensions, 10.5
  VALUES LESS THAN clause, 5.5
    MAXVALUE, 5.5.1.1
  view constraints, 7.3.7, 18.3.5
  views
    DBA_DATA_FILES, 25.6.7.7
    DBA_EXTENTS, 25.6.7.7
    GV$FILESTAT, 25.6.7
    V$FILESTAT, 25.6.7.7
    V$PARAMETER, 25.6.7.8
    V$PQ_SESSTAT, 25.6.5, 25.6.7.6
    V$PQ_SYSSTAT, 25.6.5
    V$PQ_TQSTAT, 25.6.6, 25.6.7.9
    V$PX_PROCESS, 25.6.7.4, 25.6.7.5
    V$PX_SESSION, 25.6.7.2
    V$PX_SESSTAT, 25.6.7.3
    V$SESSTAT, 25.6.7.10, 25.6.10
    V$SYSSTAT, 25.6.7.10, 25.8.8.7
  vmstat UNIX command, 25.6.10
  VPD
    and materialized views, 9.5.1
    restrictions with materialized views, 9.5.1.2

## W

  WIDTH_BUCKET function, 21.13, 21.13.1
  window functions, 22.3.5
  windowing functions, 21.3
  workloads
    distribution, 25.6.6
    skewing, 25.4.4

## X

  XIDSEQ$
    control column, 16.9.3.2
  XIDSLT$
    control column, 16.9.3.2
  XIDUSN$
    control column, 16.9.3.2